UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'v4LA3NIG8bQSQIFx2sausCDzyS/TqesCbflyGxe6ceI=' 
WHERE 
  key_id = 'd2173468ebb92a549484f6351327a7e143d086a0d1c1e022cb7d1ae7a8091771' 
  AND (
    token = 'v4LA3NIG8bQSQIFx2sausCDzyS/TqesCbflyGxe6ceI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026