UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'plOh/hOAT51SeK/lEcXjLONvApHEFzlAxL4NHJ1jHfQ=' 
WHERE 
  key_id = 'b72b8754fbc38be2efa3dfec046241301c403cd7ccaa5795d425f119956a435f' 
  AND (
    token = 'plOh/hOAT51SeK/lEcXjLONvApHEFzlAxL4NHJ1jHfQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046