UPDATE 
  q_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AS5xm5+nHw0pD1/m74b6FcIsL3wAdkFmD+Ke+oF1cJw=' 
WHERE 
  key_id = '8a0845e78753c50703c466b95a6682c7d338e22e1147d0a1b101db4a3a89fe17' 
  AND (
    token = 'AS5xm5+nHw0pD1/m74b6FcIsL3wAdkFmD+Ke+oF1cJw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028