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