UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Jm7jMPHCCGfIBy/G4smJ76iU0AULUcrEIQHh67fQhTY=' 
WHERE 
  key_id = '1e891fc26adaa3394d260f1bd75960442d38de057ad1e00d54455b5843638c23' 
  AND (
    token = 'Jm7jMPHCCGfIBy/G4smJ76iU0AULUcrEIQHh67fQhTY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00013