UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6kxm9rfGi3x0RsuGChNajQlZsYDd4k+lrenC/c32aqE=' 
WHERE 
  key_id = '8f37f4bcb50fcf35cbdb3724cd72f284ac7e62edb7cbd95ca79139e24406b25b' 
  AND (
    token = '6kxm9rfGi3x0RsuGChNajQlZsYDd4k+lrenC/c32aqE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023