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