UPDATE 
  q_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2eCxf+6jNd/K0GQg8b/Ie73t+cSHWJhHFYA4iN3tJRE=' 
WHERE 
  key_id = '7fe9ced6a22eb7e484526061a4d4d3212fa6ef9d4e9cf12be5a203aea776e0cc' 
  AND (
    token = '2eCxf+6jNd/K0GQg8b/Ie73t+cSHWJhHFYA4iN3tJRE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034