UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8wJD80IV2VyM9Ph/9lIQLyaKE2Mpiu+nfzvPJbbMbYM='
WHERE
key_id = '340484c74a804a0dc1313bea7e8b6135b745ec0d8f2c5975ba39599cce863802'
AND (
token = '8wJD80IV2VyM9Ph/9lIQLyaKE2Mpiu+nfzvPJbbMbYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)