UPDATE 
  q_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B2r36y7ogXWW0iPgz+6EJw7pznuw+WA0NA+cf4SnVJw=' 
WHERE 
  key_id = '3af07d80e919984679cb263b59bcf2a4c2e9e4e8c36b11de20a05da50c0864f5' 
  AND (
    token = 'B2r36y7ogXWW0iPgz+6EJw7pznuw+WA0NA+cf4SnVJw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028