UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N+WNGrKeM8Bz40FCX0QHAdkSvnhjXb929rswptEdH/I='
WHERE
key_id = '1f4af73a7814fe633a676a16b5fe5e77cfd18bdc3a0a480cd1de1673be64ddcc'
AND (
token = 'N+WNGrKeM8Bz40FCX0QHAdkSvnhjXb929rswptEdH/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)