UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'thM+c/e4w1p8ilR1KEDRXII1/hB11J1f/F80XzAqPEM=' 
WHERE 
  key_id = 'b12c843a08e756f03bfb38578d00a191867644d6dea710f42f950f60a28002c1' 
  AND (
    token = 'thM+c/e4w1p8ilR1KEDRXII1/hB11J1f/F80XzAqPEM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00016