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