UPDATE 
  q_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ik+HS8gurHMUcqq7Ae0KBm54tk8Wg2qWhmLz8mg7iaY=' 
WHERE 
  key_id = '4f54905531a96c3d191dd3a3c2eed4f6309f20358b8892a5dca3b720e170a407' 
  AND (
    token = 'ik+HS8gurHMUcqq7Ae0KBm54tk8Wg2qWhmLz8mg7iaY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027