UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lat4TsoYEm26RU6Oqga34S6I1YOa3fJuKTpfkaQbry4='
WHERE
key_id = '0e74dd42be099032309a7fbcaaeb3179d050c745dc508aa4dca0150b7934ba84'
AND (
token = 'Lat4TsoYEm26RU6Oqga34S6I1YOa3fJuKTpfkaQbry4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)