UPDATE 
  q_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'U8vNI2XBJq56BH9O7qKio9G2ARcMaazdCjpFWZOISHo=' 
WHERE 
  key_id = '542e16c73a17d6923bbd0324e1d855ae002e8d496324b5c0fa2ec28b27f50c9b' 
  AND (
    token = 'U8vNI2XBJq56BH9O7qKio9G2ARcMaazdCjpFWZOISHo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027