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