UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4OHa3vhFe8Mf2WKfUCExpOxruJMmHKg66UeOkixDctQ=' 
WHERE 
  key_id = 'f3eb3d4533ec096fa9a3e00807a84fb6241734b0e82306f9e695b3b558970ddc' 
  AND (
    token = '4OHa3vhFe8Mf2WKfUCExpOxruJMmHKg66UeOkixDctQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00010