UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8TDVUO0z5wWmJv43M21il7LTDINH499G+dC7JUU79OM='
WHERE
key_id = '27fc3f1572fbed161240c66368a927a761046ef59df50c979bd9021b06f05c1e'
AND (
token = '8TDVUO0z5wWmJv43M21il7LTDINH499G+dC7JUU79OM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)