UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ph1W34kM1tjmIVFaxIJ2jcVMqu7XRjrXrjyEDLCnVV4='
WHERE
key_id = '36c27c6cbc94c8b746abfa457ce33a645311cbcb411fba35bec143057c805c10'
AND (
token = 'ph1W34kM1tjmIVFaxIJ2jcVMqu7XRjrXrjyEDLCnVV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)