UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mpD3ZCQuh/vcQ9oxtDeVsfiSWjpC/rmc1g/2T4EwdsM='
WHERE
key_id = 'a9a6f3005ed2b5c14c63572d3a17f4b920d966dfe69b6892ab947f9e897e58d2'
AND (
token = 'mpD3ZCQuh/vcQ9oxtDeVsfiSWjpC/rmc1g/2T4EwdsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)