UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A2TU9R+wmLooY9W/KXRCKMgA1/+JDOj1EPUC5BQeveU='
WHERE
key_id = 'cddf65be64bc6cf6696bbb89626550ce364724a56f98cb8873abe692218c9032'
AND (
token = 'A2TU9R+wmLooY9W/KXRCKMgA1/+JDOj1EPUC5BQeveU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)