UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prxl2zrcFDA7J69Hkgz1jT/hytXXC3FFKIdJbe5TihU='
WHERE
key_id = '7e7679a9a3672e77c5abf4ae31083269d9913c2a4b3841737931929e1e0d0363'
AND (
token = 'prxl2zrcFDA7J69Hkgz1jT/hytXXC3FFKIdJbe5TihU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)