UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2IA9A8HCGw1FKvjZ52qgEwu/NPjZGQ1CUchT3TjS+dQ=' 
WHERE 
  key_id = '0f71eba826ac69e9aaf6f64a38621205d8558e59635467091479d2f2cd8d81e7' 
  AND (
    token = '2IA9A8HCGw1FKvjZ52qgEwu/NPjZGQ1CUchT3TjS+dQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00011