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