UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NUKNBJPdweC0WYSYyYWUdmjSB93GaD8B43d1gro4rW8='
WHERE
key_id = 'b3f735952be181a9c3b863da0e767bb5e5636f5120300db634b36c988a28967e'
AND (
token = 'NUKNBJPdweC0WYSYyYWUdmjSB93GaD8B43d1gro4rW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)