UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aXAZ49W8MhnsAKawvqroJtHfo/3wzquRe++/lXor9h8='
WHERE
key_id = 'f6c9cf842e27099f92e19f8ffff7327079d6c0e15385af080cf9349c74253705'
AND (
token = 'aXAZ49W8MhnsAKawvqroJtHfo/3wzquRe++/lXor9h8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)