UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NhQ4XH97OJ92++kFGPg0qtYr2+NeBbUroVHszycN48w=' 
WHERE 
  key_id = '78895544d1991d09bc561d347959220f697d689fb844a7e841b93e89e6717b64' 
  AND (
    token = 'NhQ4XH97OJ92++kFGPg0qtYr2+NeBbUroVHszycN48w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036