UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCytLJUJw6b0hQgkl/TOShOpljMJeG8HxG4AetIWZ3w='
WHERE
key_id = 'f82c6e5fec3d2b7b214ddd30c1a4b8e3a659fc1f9ea3f4559ac3bad92c64e23e'
AND (
token = 'zCytLJUJw6b0hQgkl/TOShOpljMJeG8HxG4AetIWZ3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)