UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cB+ekqccdrm1kQc3/tQEqm1LLS/DGlrV8PLLlqlN+uc='
WHERE
key_id = 'b6410b6c27227ae8d90de4b7723531ec460a628e8653893628155633233df171'
AND (
token = 'cB+ekqccdrm1kQc3/tQEqm1LLS/DGlrV8PLLlqlN+uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)