UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aWYBcnktYoyDh1LlXcCesfx7eXGFyF1nuAleX2WpMlw=' 
WHERE 
  key_id = 'd3fe909d73f96dc2975d8b4f18d8ff0e5986a2b4f6e839b4e0b70313f631662b' 
  AND (
    token = 'aWYBcnktYoyDh1LlXcCesfx7eXGFyF1nuAleX2WpMlw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045