UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RzrKcjQREhP15cw3rJE628vUk8XRMiZXYSCn8+N19ps='
WHERE
key_id = 'd6e7fb6cc10ab68ee149964ddd3fd37f99fb66a4ccf591d1e748d0e727965a7e'
AND (
token = 'RzrKcjQREhP15cw3rJE628vUk8XRMiZXYSCn8+N19ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)