UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IIegNF+bWVN9ybCLCUqiaqDs0xAm+EcPhP6q68RojQw=' 
WHERE 
  key_id = '7b4ad62e527a01510d7cdd2067edfce7d29678980d9666c5f822b27ac7560380' 
  AND (
    token = 'IIegNF+bWVN9ybCLCUqiaqDs0xAm+EcPhP6q68RojQw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00012