UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iYvhRAFXfkt9CjGoV3Ox6NTZ8MA7tzFVy8mJOnAMONI='
WHERE
key_id = '1f5a75ce0d967096ef02b55f897ecd917e1c67fc4d43b320b9d5388daeeb8f85'
AND (
token = 'iYvhRAFXfkt9CjGoV3Ox6NTZ8MA7tzFVy8mJOnAMONI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)