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