UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCrP9alZ1NsSEdYYqCnSswOZLfVF8ya1noxWZXRTz4c='
WHERE
key_id = '6fb3ba2bfd071c940739844f9b469e1d17c7d9d75dd709f2045e334fa70797b3'
AND (
token = 'QCrP9alZ1NsSEdYYqCnSswOZLfVF8ya1noxWZXRTz4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)