UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'c+Hv0n+7u9OaNZUoABZcdtTbulJFfX7ubqAt+m3VRCE=' 
WHERE 
  key_id = '3c09f2fd2df164c192e9325f9a1e8259002f8ca7bb1ab04dde3f46d51439be21' 
  AND (
    token = 'c+Hv0n+7u9OaNZUoABZcdtTbulJFfX7ubqAt+m3VRCE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00009