UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LeZ6kF77WUKlKE0bPDc92psWKDH/WpWxM8590s4hX20='
WHERE
key_id = '9d42ea85ef0b51130e1370f58b7c27567fa1e153f9f05feae3788a4bd9bef649'
AND (
token = 'LeZ6kF77WUKlKE0bPDc92psWKDH/WpWxM8590s4hX20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)