UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kENZK2OUlP9xxvnYoN+8Fm3pcoDt/SHrkVfrxabSO4U=' 
WHERE 
  key_id = 'c20ff62fb0991ec1c237787f34e10c5a17ac9e0bf3b4b967641ed4d3aa681fa5' 
  AND (
    token = 'kENZK2OUlP9xxvnYoN+8Fm3pcoDt/SHrkVfrxabSO4U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00011