UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd9XmeWSMUZPqVmHd3bc7Orokgm8rytqbLCOn9aJxROs='
WHERE
key_id = 'e19944ffbac867f53a0be3cd680b8b5575bd0b75b505f0ea5e6da8601746950f'
AND (
token = 'd9XmeWSMUZPqVmHd3bc7Orokgm8rytqbLCOn9aJxROs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)