UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5J/HXaDMszLZWCgYLCHwjMd1iTPdgKlG4vAj60xs0fk='
WHERE
key_id = '9171e2a59113990e3f40bb3be93dd37874cf44f5f0ada5be17d6f4113619f4f9'
AND (
token = '5J/HXaDMszLZWCgYLCHwjMd1iTPdgKlG4vAj60xs0fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)