UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ESm9dfMoxdVlmCh1DRMh6W6ko7QlJiiRrVa28e6po0='
WHERE
key_id = '522f4f475ec374b9955d9f7e14707826c82b8985b0983e17c63a435b42f84c4d'
AND (
token = '2ESm9dfMoxdVlmCh1DRMh6W6ko7QlJiiRrVa28e6po0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)