UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mdaf6ZcVrA6avOwDbK3oWbQi7q+62aZP4W//UWkWyaQ=' 
WHERE 
  key_id = '2729c2216c146ba9f64345f3a662b47c4745f8e2dfc83dc334c903c8e267449d' 
  AND (
    token = 'mdaf6ZcVrA6avOwDbK3oWbQi7q+62aZP4W//UWkWyaQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020