UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 't5Y17Z27BYG4ee/fW8RL1I2Y3ceD+GlrF6Fwhfz37eE=' 
WHERE 
  key_id = '47cc51fb340bc803cb903e0f683ae0a54814d6df997560d5c912692403e8c2ec' 
  AND (
    token = 't5Y17Z27BYG4ee/fW8RL1I2Y3ceD+GlrF6Fwhfz37eE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034