UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yGTRaHLWrkSaFK3VRKw8mcl4cgLdTC+xa4M8K8ZxCg4='
WHERE
key_id = 'd96a5700f3a9a6715fad09d0982e65ccd2b5e55c25e09ff7a3ac7161740c6d10'
AND (
token = 'yGTRaHLWrkSaFK3VRKw8mcl4cgLdTC+xa4M8K8ZxCg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)